SQL statements that are configured in the program by XML to be converted to C # supported SQL statements a.*(select top 1 (select COUNT (*) from Omsorder as a, left join Sysstate as B on (a.[state] = B.value and b.statetype= ' Statede Fault ') where
First, the escape character is used to configure the Xml file in Mybatis. Strictly speaking, it is invalid to have only the characters "& lt;" and "& amp;" in XML. Ellipsis, quotation marks, and greater than signs are valid, but it is a good habit
When we need to pass xml format processing sql statements are often used ,,>,>=xml format error, which causes the background to xml string converted to xml document times wrong, resulting in a program error. Such problems often need us to deal
When we need to process SQL statements in XML format, we often use symbols such as ,>= and so on, but it is easy to cause errors in XML format, which causes the background to convert XML strings to XML document times, which can lead to program
Zhou (zhoujtnet@yahoo.com.cn) National Professional Laboratory of CAD/CAM, Northwestern Polytechnical University
Wang Ming Micro (wangmv@hotmail.com) Northwest University of Technology CAD/CAM National Professional Laboratory
July 01, 2002
XML DTD
Because this is an XML file that does not allow characters like ">" to appearUse the escape character to replace > and XML escape character
Field
symbols
Description
Less than sign
The XML document contains text similar to "Elements looks like ", where "" interprets the parser as an element, and what people actually want is the literal text that "" represents.
1.CDATA Zone: It's all called character data, to ""begins with the"
When we need to process SQL statements in XML format, we often use symbols such as ,>= and so on, but it is easy to cause errors in XML format, which causes the background to convert XML strings to XML document times, which can lead to program
should be used in SQL for business requirements >=,
The first: replace > and
SELECT * FROM Test WHERE 1 = 1 and start_date
Attachment: XML escape characters
&nbs P
Because this is an XML file that does not allow characters like ">" to appearUse the escape character to replace > and XML escape character
Field
symbols
Description
Less than sign
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.